home *** CD-ROM | disk | FTP | other *** search
/ Power Tools 1993 November - Disc 2 / Power Tools Plus (Disc 2 of 2)(November 1993)(HP).iso / hotlines / gsyhl / dbfeat / swag.txt < prev    next >
Text File  |  1993-04-02  |  28KB  |  513 lines
  1.            STRATEGIC PROFILE OF THIRD-PARTY RELATIONAL DATABASES
  2.  
  3.                         ------SOFTWARE AG VER 1.2-----
  4.  
  5. LANGUAGES SUPPORT
  6. ------------------------------------------------------------------------
  7. Japanese                                     Yes in 4Q '92
  8.                                              German, French ... about
  9. Hanggui                                      60 languages
  10. ------------------------------------------------------------------------
  11. Sorting Sequences                            Yes; EBCDIC and ASCII
  12. ------------------------------------------------------------------------
  13. Error messges                                Yes
  14. ------------------------------------------------------------------------
  15. Upper/Lower case conversion                  Yes
  16. ------------------------------------------------------------------------
  17. Sorting/Collating sequences                  Yes
  18. ------------------------------------------------------------------------
  19. Multiple character set support               Yes
  20. ------------------------------------------------------------------------
  21. 2-Byte character set                         Yes; 4Q '92
  22. ------------------------------------------------------------------------
  23.  
  24.  
  25. GRAPHICS PRESENTATION                        "Entire" GUI
  26. ------------------------------------------------------------------------
  27. WYSIWYG environment                          No
  28. ------------------------------------------------------------------------
  29. Product graphics directly from query         No
  30.  
  31.  
  32. CONNECTIVITY/GATEWAYS
  33. ------------------------------------------------------------------------
  34. DB2 Connectivity                             DB2, RDB, IMS, RMS, VSAM,
  35. VAX VMS, IMS, ALLBASE,                       DMS
  36. ORACLE, RDB
  37. -------------------------------------------------------------------------
  38. PC Integration                               Yes; OS/2, Windows, DOS,
  39.                                              Macintosh
  40. PORTABILITY
  41. ------------------------------------------------------------------------
  42. ANSI 89 (level 2) compatibility             No
  43. ------------------------------------------------------------------------
  44. Hardware Platform Supported                 IBM Mainframe, VAX, IBM PCs
  45.                                             Wang, NCR, Unix systems,
  46.                                             HP9000
  47. ------------------------------------------------------------------------
  48. Operating System Supported                  MVS/XA, MVS/ESA, VAX/VMS,
  49.                                             VSE, OS2000, UNIX, DOS,
  50.                                             Windows, OS/400, OS/2,
  51.                                             HP-UX
  52. ------------------------------------------------------------------------
  53. Support for Non-Relational Database         Yes
  54. ------------------------------------------------------------------------
  55.  
  56.  
  57. DATA TYPES
  58. -------------------------------------------------------------------------
  59. Character                                   Yes
  60. ------------------------------------------------------------------------
  61. Integer                                     Yes
  62. ------------------------------------------------------------------------
  63. Float                                       Yes
  64. ------------------------------------------------------------------------
  65. Logical                                     Yes
  66. ------------------------------------------------------------------------
  67. Currency                                    Yes
  68. ------------------------------------------------------------------------
  69. Date                                        Yes
  70. ------------------------------------------------------------------------
  71. Time                                        Yes
  72. ------------------------------------------------------------------------
  73. Long Text                                   No
  74. ------------------------------------------------------------------------
  75. Image (BLOBS)                               No
  76. ------------------------------------------------------------------------
  77. Support for Arrays                          Yes
  78. ------------------------------------------------------------------------
  79. User defined data type                      No
  80. ------------------------------------------------------------------------
  81. User defined functions and operators        Yes
  82. ------------------------------------------------------------------------
  83. Binary (Fixed / Var)                        Yes
  84. ------------------------------------------------------------------------
  85. Sound                                       No
  86. ------------------------------------------------------------------------
  87. Graphics                                    No
  88. ------------------------------------------------------------------------
  89. Facsimiles                                  No
  90.  
  91.  
  92. DISTRIBUTION
  93. ------------------------------------------------------------------------
  94. Parallel Server
  95. ------------------------------------------------------------------------
  96. Location Transparency                       Yes
  97. ------------------------------------------------------------------------
  98. Distributed Query Processing                Yes
  99. ------------------------------------------------------------------------
  100. Distributed query optimizer                 No
  101. ------------------------------------------------------------------------
  102. Distributed transaction processing          Yes
  103. (2-phase commit)
  104. ------------------------------------------------------------------------
  105. Support for data replication                Yes
  106. ------------------------------------------------------------------------
  107. Access to heterogeneous databases           Yes, 1Q '93
  108. ------------------------------------------------------------------------
  109. Loosely coupled support                     Yes
  110. ------------------------------------------------------------------------
  111. Distributed data dictionary
  112. ------------------------------------------------------------------------
  113. Max. no. of simultaneously connected dbs    255
  114.  
  115.  
  116. ARCHITECTURE
  117. ------------------------------------------------------------------------
  118. Client/Server                               Yes
  119. ------------------------------------------------------------------------
  120. Multiserver                                 Yes
  121. ------------------------------------------------------------------------
  122. Maximum number of server/systems            No limit
  123. ------------------------------------------------------------------------
  124. Maximum number of user/server               Platform dependent
  125. ------------------------------------------------------------------------
  126. Maxiumu number of user/system               No limit
  127. ------------------------------------------------------------------------
  128. Multithreaded server                        yes
  129. ------------------------------------------------------------------------
  130. Support for symmetric multiprocessors       Yes
  131. ------------------------------------------------------------------------
  132. Open architecture (APIs available)          Yes
  133. ------------------------------------------------------------------------
  134. Loosely coupled support                     Yes
  135. ------------------------------------------------------------------------
  136.  
  137.  
  138. UNDERLYING FILE STRUCTURE                   B-tree, inverted list
  139. ------------------------------------------------------------------------
  140. DATABASE PARAMETERS
  141. -------------------------------------------------------------------------
  142. Database size                               No limit
  143. ------------------------------------------------------------------------
  144. Database/server                             No limit
  145. ------------------------------------------------------------------------
  146. Tables/database                             255
  147. ------------------------------------------------------------------------
  148. Records/database                            No limit
  149. ------------------------------------------------------------------------
  150. Record size                                 32k
  151. ------------------------------------------------------------------------
  152. Fields/record                               936
  153. ------------------------------------------------------------------------
  154. Indexes/database                            256 x 255
  155. ------------------------------------------------------------------------
  156. Database connected to a client              No limit
  157. ------------------------------------------------------------------------
  158.  
  159.  
  160. USER INTERFACE                              Menu-driven
  161. ------------------------------------------------------------------------
  162. Menu bypass                                 Yes
  163. ------------------------------------------------------------------------
  164. Contextual help                             Yes
  165. ------------------------------------------------------------------------
  166. Tutorial                                    Yes
  167. ------------------------------------------------------------------------
  168. Ability to customize standard menus         Yes
  169. ------------------------------------------------------------------------
  170. Support for colors                          Yes; 4Q '92
  171. ------------------------------------------------------------------------
  172. Support for graphical user interface        Yes; 4Q '92
  173. ------------------------------------------------------------------------
  174.  
  175.  
  176. SCREEN FORMS
  177. ------------------------------------------------------------------------
  178. Default form generator                      Yes
  179. ------------------------------------------------------------------------
  180. Customized                                  Yes
  181. ------------------------------------------------------------------------
  182. Multiple tables/forms                       Yes
  183. ------------------------------------------------------------------------
  184. Multiple screens/forms                      Yes
  185. ------------------------------------------------------------------------
  186. Embedded processing (if-then-else, display  Yes
  187.                     aggregates)
  188. ------------------------------------------------------------------------
  189.  
  190.  
  191. FIELD ATTRIBUTES ON FORMS
  192. ------------------------------------------------------------------------
  193. Case conversion                             Yes
  194. ------------------------------------------------------------------------
  195. Default Value                               Yes
  196. ------------------------------------------------------------------------
  197. Required field                              Yes
  198. ------------------------------------------------------------------------
  199. Acceptable values                           No
  200. ------------------------------------------------------------------------
  201. Verification (enter data twice)             Yes
  202. ------------------------------------------------------------------------
  203. Formatting of data                          Yes
  204. ------------------------------------------------------------------------
  205. Calculated fields                           Yes
  206. ------------------------------------------------------------------------
  207. Display/read only (no entry/update)         Yes
  208. ------------------------------------------------------------------------
  209. Hidden                                      Yes
  210. ------------------------------------------------------------------------
  211. Prompt (for data entry)                     Yes
  212. ------------------------------------------------------------------------
  213. Customized help                             Yes
  214. ------------------------------------------------------------------------
  215. Video display                               Yes
  216. ------------------------------------------------------------------------
  217. Ability to change field attribute           Yes
  218.      dynamically
  219. ------------------------------------------------------------------------
  220.  
  221.  
  222. QUERY-BY-FORMS
  223. ------------------------------------------------------------------------
  224. Exact match                                 Yes
  225. ------------------------------------------------------------------------
  226. Relational operators                        Yes
  227. ------------------------------------------------------------------------
  228. List of values                              Yes
  229. ------------------------------------------------------------------------
  230. Wild cards                                  Yes
  231. ------------------------------------------------------------------------
  232. Maximum/Minimum values                      Yes
  233. ------------------------------------------------------------------------
  234. Print query results                         Yes
  235. ------------------------------------------------------------------------
  236. Pass results to report writer               Yes
  237. ------------------------------------------------------------------------
  238. Text search                                 Yes
  239. ------------------------------------------------------------------------
  240.  
  241.  
  242. SQL                                         SQL support available in
  243.                                             4Q '92
  244. ------------------------------------------------------------------------
  245. Standard SQL statements                     Yes
  246. ------------------------------------------------------------------------
  247. Data Definition language (DDL)              Yes
  248. ------------------------------------------------------------------------
  249. Data manipulation language (DML)            Yes
  250. ------------------------------------------------------------------------
  251. Extension to SQL                            Yes
  252. ------------------------------------------------------------------------
  253. Commit/rollback transaction                 Yes
  254. ------------------------------------------------------------------------
  255. Execute operating systems commands          No
  256. ------------------------------------------------------------------------
  257. Load/unload data to/from ASCII file         Yes
  258. ------------------------------------------------------------------------
  259. Additional data definition statements       Yes
  260. ------------------------------------------------------------------------
  261. Control-of-flow logic                       Yes
  262. ------------------------------------------------------------------------
  263. Support for embedded SQL                    Yes
  264. ------------------------------------------------------------------------
  265. Suport for dynamic SQL                      Yes
  266. ------------------------------------------------------------------------
  267. Can create new tables with query results    No
  268. ------------------------------------------------------------------------
  269. Stored queries                              Yes
  270. ------------------------------------------------------------------------
  271. CASE-insensitive (eg., filed names)         Yes
  272. ------------------------------------------------------------------------
  273. Can call C routines                         Yes
  274. ------------------------------------------------------------------------
  275. How create SQL queries/statements           Using standard SQL syntax
  276. ------------------------------------------------------------------------
  277. Query optimizer-statistical                 Yes
  278. ------------------------------------------------------------------------
  279. Syntax independent performance              Yes
  280. ------------------------------------------------------------------------
  281. Optimization method                         Dynamic statistical
  282. ------------------------------------------------------------------------
  283. Procedural extension to SQL                 Yes
  284. ------------------------------------------------------------------------
  285. Remote SQL database calls                   Yes
  286. ------------------------------------------------------------------------
  287.  
  288.  
  289. B-TREE INDEXING
  290. -------------------------------------------------------------------------
  291. Maximum number of indexes                   256
  292. ------------------------------------------------------------------------
  293. Maximum number of fields/index
  294. ------------------------------------------------------------------------
  295. Maximum size of index key                   253
  296. ------------------------------------------------------------------------
  297. Order options                               Ascending
  298. ------------------------------------------------------------------------
  299. Unique index                                Yes
  300. ------------------------------------------------------------------------
  301. Clustered index                             No
  302. ------------------------------------------------------------------------
  303. Other file access methods (hash, etc.)      Sequential, key, internal
  304.                                             sequent number
  305. ------------------------------------------------------------------------
  306.  
  307.  
  308. REPORT WRITER
  309. ------------------------------------------------------------------------
  310. Non Procedural                              Yes
  311. ------------------------------------------------------------------------
  312. Default report generator                    Yes
  313. ------------------------------------------------------------------------
  314. Interactive report generator                Yes
  315.      using screen forms
  316. ------------------------------------------------------------------------
  317. Interactive debugging                       Yes
  318. ------------------------------------------------------------------------
  319. Input source                                Yes
  320. ------------------------------------------------------------------------
  321. Multiple tables                             Yes
  322. ------------------------------------------------------------------------
  323. Page formatting                             Yes
  324. ------------------------------------------------------------------------
  325. Headers and footers                         Yes
  326. ------------------------------------------------------------------------
  327. Data formatting                             Yes
  328. ------------------------------------------------------------------------
  329. Sort data                                   Yes
  330. ------------------------------------------------------------------------
  331. Aggregate functions                         Yes
  332. ------------------------------------------------------------------------
  333. Logical processing (if-then logic)          Yes
  334. ------------------------------------------------------------------------
  335. User variables                              Yes
  336. ------------------------------------------------------------------------
  337. Prompt for input variables at run time      Yes
  338. ------------------------------------------------------------------------
  339.  
  340.  
  341. APPLICATION GENERATOR
  342. ------------------------------------------------------------------------
  343. CASE Tools                                  Yes; 4Q '92
  344. ------------------------------------------------------------------------
  345. 4GL Interface                               Yes
  346. ------------------------------------------------------------------------
  347. Ability to design application menus         Yes
  348. ------------------------------------------------------------------------
  349. Default menu generator                      Yes; 4Q '92
  350. ------------------------------------------------------------------------
  351. Custom help                                 Yes
  352. ------------------------------------------------------------------------
  353. Consistent module interface                 Yes
  354. ------------------------------------------------------------------------
  355. Toolset for multimedia application          No
  356. ------------------------------------------------------------------------
  357.  
  358. ABILITY TO CREATE VIEWS                     Yes
  359. ---------------------------------------------------------------------------
  360.  
  361.  
  362. INTEGRITY                                   Yes
  363. --------------------------------------------------------------------------
  364. Transaction logging                         Yes
  365. ------------------------------------------------------------------------
  366. Commit/rollback transaction                 Yes
  367. ------------------------------------------------------------------------
  368. Roll forward                                Yes
  369. ------------------------------------------------------------------------
  370. Referential integrity                       Declarative
  371. ------------------------------------------------------------------------
  372. Field validation                            Yes
  373. ------------------------------------------------------------------------
  374. Support for business rules                  Yes
  375. ------------------------------------------------------------------------
  376. Database Triggers                           Yes; user program control
  377. ------------------------------------------------------------------------
  378. Database event alerters
  379. ------------------------------------------------------------------------
  380. Entity integrity                            Yes
  381. ------------------------------------------------------------------------
  382. Domain Integrity                            Yes
  383. ------------------------------------------------------------------------
  384.  
  385.  
  386. STORED PROCEDURES                           Yes; under program control
  387. ------------------------------------------------------------------------
  388. Precompiled                                 Yes; under program control
  389. ------------------------------------------------------------------------
  390. Can be nested                               Yes; under program control
  391. ------------------------------------------------------------------------
  392. Ability to store and execute                Yes; under program control
  393.      procedures on the server
  394. ------------------------------------------------------------------------
  395.  
  396.  
  397. CONCURRENCY CONTROL LOCKING LEVELS
  398. ------------------------------------------------------------------------
  399. Database                                    No
  400. ------------------------------------------------------------------------
  401. Table                                       Yes; optional
  402. ------------------------------------------------------------------------
  403. Record (row)                                Yes
  404. ------------------------------------------------------------------------
  405. Page                                        No
  406. ------------------------------------------------------------------------
  407. Lock type:  shared, update, exclusive       Shared, update, and exclusive
  408. ------------------------------------------------------------------------
  409. Deadlock recognition                        Yes
  410. ------------------------------------------------------------------------
  411. Other data isolation levels
  412.  
  413.  
  414. DATABASE SECURITY
  415. ------------------------------------------------------------------------
  416. Login password                              Yes
  417. ------------------------------------------------------------------------
  418. Multilevel access control                   Yes
  419. ------------------------------------------------------------------------
  420.      User                                   Yes
  421. ------------------------------------------------------------------------
  422.      Group                                  Yes
  423. ------------------------------------------------------------------------
  424.      Application                            Yes
  425. ------------------------------------------------------------------------
  426. Database-level access                       Yes
  427. ------------------------------------------------------------------------
  428. Table-level access                          Yes
  429. ------------------------------------------------------------------------
  430. Record-level access                         No
  431. ------------------------------------------------------------------------
  432. Field-level access                          Yes; 4Q '92
  433. ------------------------------------------------------------------------
  434. Access by time of day                       Yes; 4Q '92
  435. ------------------------------------------------------------------------
  436. Access by location (workstation)            Yes; 4Q '92
  437. ------------------------------------------------------------------------
  438. Ability to define resource limits on user   Yes
  439.      queries (same as create views?)
  440. ------------------------------------------------------------------------
  441.  
  442.  
  443. AVAILABILITY
  444. ------------------------------------------------------------------------
  445. On-line backup                              Yes
  446. ------------------------------------------------------------------------
  447. On-line database changes                    Yes
  448. ------------------------------------------------------------------------
  449. Software-based disk mirroring               No; support hardware based
  450. ------------------------------------------------------------------------
  451.  
  452. Raw Input-Output                            Yes
  453. ------------------------------------------------------------------------
  454.  
  455. Database can scan multiple physical
  456.      devices (disks)                        Yes
  457. ------------------------------------------------------------------------
  458.  
  459. Support for CD-ROM, WORM Drives             Yes
  460. ------------------------------------------------------------------------
  461.  
  462.  
  463. NETWORK SUPPORT                             TCP-IP, SNA LU6.2, DECNet,
  464.                                             (only supports TCP-IP on HP)
  465. ------------------------------------------------------------------------
  466.  
  467.  
  468. IMPORT / EXPORT CAPABILITY
  469. ------------------------------------------------------------------------
  470. Import formats                              ASCII delimited, fixed field
  471. ------------------------------------------------------------------------
  472. Export formats                              ASCII delimited, fixed field
  473. ------------------------------------------------------------------------
  474.  
  475.  
  476. DATABASE ADMINISTRATION
  477. ------------------------------------------------------------------------
  478. Screen based administrative utilities       Yes
  479. ------------------------------------------------------------------------
  480. Performance tuning                          Yes
  481. ------------------------------------------------------------------------
  482. Dynamic modification                        Yes
  483. ------------------------------------------------------------------------
  484. Dynamic disk space allocation               Yes
  485. ------------------------------------------------------------------------
  486.  
  487.  
  488. I/O REDUCTION TECHNIQUES
  489. ------------------------------------------------------------------------
  490. Fast Commit                                 Yes
  491. ------------------------------------------------------------------------
  492. Group Commit                                Yes
  493. ------------------------------------------------------------------------
  494. Parallel Checkpoint on multiprocessor       Yes
  495.      systems
  496. ------------------------------------------------------------------------
  497. Index compression                           No
  498. ------------------------------------------------------------------------
  499. Data compression                            Yes
  500. ------------------------------------------------------------------------
  501. Multiblock Read/Write                       Yes
  502. ------------------------------------------------------------------------
  503.  
  504.  
  505. FAULT-TOLERANCE
  506. ------------------------------------------------------------------------
  507. Mirrored Discs                              Yes; if hardware supports it
  508. ------------------------------------------------------------------------
  509. Disc Failures                               Yes
  510. ------------------------------------------------------------------------
  511. CPU Failures                                Yes
  512. ------------------------------------------------------------------------
  513.